<?php

$installer = $this;

$installer->startSetup();

$installer->run("

-- DROP TABLE IF EXISTS {$this->getTable('backend')};
CREATE TABLE {$this->getTable('backend')} (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL,
  `store_id` int(11) unsigned NOT NULL,
  `commission` decimal(20,4) unsigned NOT NULL,
  `customer_id` int(11) unsigned NOT NULL,
  `filename_logo` text NOT NULL default '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO {$this->getTable('backend')} (
`id` ,
`user_id` ,
`store_id` ,
`commission` ,
`customer_id` ,
`filename_logo`
)
VALUES (
'0', '0', '0', '0', '0', 'Blank'
);

    ");

$installer->endSetup(); 